Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 5763 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 540.3 KiB |
| Average record size in memory | 96.0 B |
Variable types
| Numeric | 11 |
|---|
gross_revenue is highly overall correlated with total_invoices and 3 other fields | High correlation |
recency_days is highly overall correlated with total_invoices | High correlation |
frequency is highly overall correlated with total_invoices and 1 other fields | High correlation |
total_invoices is highly overall correlated with gross_revenue and 5 other fields | High correlation |
items_qtt is highly overall correlated with gross_revenue and 4 other fields | High correlation |
products_qtt is highly overall correlated with gross_revenue and 4 other fields | High correlation |
avg_basket_size is highly overall correlated with gross_revenue and 3 other fields | High correlation |
avg_unique_basket_size is highly overall correlated with products_qtt and 1 other fields | High correlation |
returns_qtt is highly overall correlated with total_invoices | High correlation |
gross_revenue is highly skewed (γ1 = 21.44925486) | Skewed |
avg_ticket is highly skewed (γ1 = 53.23323582) | Skewed |
items_qtt is highly skewed (γ1 = 23.13817362) | Skewed |
avg_basket_size is highly skewed (γ1 = 49.08815403) | Skewed |
returns_qtt is highly skewed (γ1 = 52.29085591) | Skewed |
customer_id has unique values | Unique |
returns_qtt has 4207 (73.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-09-12 00:19:49.987264 |
|---|---|
| Analysis finished | 2023-09-12 00:20:28.282134 |
| Duration | 38.29 seconds |
| Software version | ydata-profiling vv4.5.1 |
| Download configuration | config.json |
customer_id
Real number (ℝ)
UNIQUE
| Distinct | 5763 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16646.304 |
| Minimum | 12346 |
|---|---|
| Maximum | 22709 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 90.0 KiB |
Quantile statistics
| Minimum | 12346 |
|---|---|
| 5-th percentile | 12702.1 |
| Q1 | 14306.5 |
| median | 16271 |
| Q3 | 18262.5 |
| 95-th percentile | 21778.9 |
| Maximum | 22709 |
| Range | 10363 |
| Interquartile range (IQR) | 3956 |
Descriptive statistics
| Standard deviation | 2833.4858 |
|---|---|
| Coefficient of variation (CV) | 0.17021711 |
| Kurtosis | -0.86084354 |
| Mean | 16646.304 |
| Median Absolute Deviation (MAD) | 1978 |
| Skewness | 0.42501083 |
| Sum | 95932651 |
| Variance | 8028641.8 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 17850 | 1 | < 0.1% |
| 21107 | 1 | < 0.1% |
| 17899 | 1 | < 0.1% |
| 13833 | 1 | < 0.1% |
| 17312 | 1 | < 0.1% |
| 17939 | 1 | < 0.1% |
| 14053 | 1 | < 0.1% |
| 16009 | 1 | < 0.1% |
| 12922 | 1 | < 0.1% |
| 21097 | 1 | < 0.1% |
| Other values (5753) | 5753 |
| Value | Count | Frequency (%) |
| 12346 | 1 | |
| 12347 | 1 | |
| 12348 | 1 | |
| 12349 | 1 | |
| 12350 | 1 | |
| 12352 | 1 | |
| 12353 | 1 | |
| 12354 | 1 | |
| 12355 | 1 | |
| 12356 | 1 |
| Value | Count | Frequency (%) |
| 22709 | 1 | |
| 22708 | 1 | |
| 22707 | 1 | |
| 22706 | 1 | |
| 22705 | 1 | |
| 22704 | 1 | |
| 22700 | 1 | |
| 22699 | 1 | |
| 22696 | 1 | |
| 22695 | 1 |
gross_revenue
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 5517 |
|---|---|
| Distinct (%) | 95.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1846.5836 |
| Minimum | 0.42 |
|---|---|
| Maximum | 280206.02 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 90.0 KiB |
Quantile statistics
| Minimum | 0.42 |
|---|---|
| 5-th percentile | 12.45 |
| Q1 | 240.87 |
| median | 632.4 |
| Q3 | 1640.115 |
| 95-th percentile | 5490.526 |
| Maximum | 280206.02 |
| Range | 280205.6 |
| Interquartile range (IQR) | 1399.245 |
Descriptive statistics
| Standard deviation | 7918.6308 |
|---|---|
| Coefficient of variation (CV) | 4.2882601 |
| Kurtosis | 600.90765 |
| Mean | 1846.5836 |
| Median Absolute Deviation (MAD) | 497.6 |
| Skewness | 21.449255 |
| Sum | 10641861 |
| Variance | 62704714 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 7.95 | 9 | 0.2% |
| 2.95 | 8 | 0.1% |
| 4.95 | 8 | 0.1% |
| 1.25 | 8 | 0.1% |
| 12.75 | 7 | 0.1% |
| 3.75 | 7 | 0.1% |
| 1.65 | 7 | 0.1% |
| 4.25 | 6 | 0.1% |
| 7.5 | 6 | 0.1% |
| 5.95 | 6 | 0.1% |
| Other values (5507) | 5691 |
| Value | Count | Frequency (%) |
| 0.42 | 1 | < 0.1% |
| 0.55 | 1 | < 0.1% |
| 0.65 | 1 | < 0.1% |
| 0.79 | 1 | < 0.1% |
| 0.84 | 3 | 0.1% |
| 0.85 | 3 | 0.1% |
| 1.07 | 1 | < 0.1% |
| 1.1 | 1 | < 0.1% |
| 1.25 | 8 | |
| 1.34 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 280206.02 | 1 | |
| 259657.3 | 1 | |
| 194550.79 | 1 | |
| 168472.5 | 1 | |
| 143825.06 | 1 | |
| 124914.53 | 1 | |
| 117379.63 | 1 | |
| 91062.38 | 1 | |
| 81024.84 | 1 | |
| 77183.6 | 1 |
avg_ticket
Real number (ℝ)
SKEWED
| Distinct | 5564 |
|---|---|
| Distinct (%) | 96.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 58.500718 |
| Minimum | 0.42 |
|---|---|
| Maximum | 77183.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 90.0 KiB |
Quantile statistics
| Minimum | 0.42 |
|---|---|
| 5-th percentile | 3.4123474 |
| Q1 | 8.505137 |
| median | 16.129773 |
| Q3 | 22.771186 |
| 95-th percentile | 80.292833 |
| Maximum | 77183.6 |
| Range | 77183.18 |
| Interquartile range (IQR) | 14.266049 |
Descriptive statistics
| Standard deviation | 1276.6179 |
|---|---|
| Coefficient of variation (CV) | 21.822261 |
| Kurtosis | 2961.2007 |
| Mean | 58.500718 |
| Median Absolute Deviation (MAD) | 7.2988374 |
| Skewness | 53.233236 |
| Sum | 337139.64 |
| Variance | 1629753.4 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3.75 | 11 | 0.2% |
| 4.95 | 10 | 0.2% |
| 2.95 | 9 | 0.2% |
| 1.25 | 9 | 0.2% |
| 7.95 | 8 | 0.1% |
| 1.65 | 7 | 0.1% |
| 8.25 | 7 | 0.1% |
| 12.75 | 7 | 0.1% |
| 3.35 | 6 | 0.1% |
| 15 | 6 | 0.1% |
| Other values (5554) | 5683 |
| Value | Count | Frequency (%) |
| 0.42 | 2 | |
| 0.535 | 1 | < 0.1% |
| 0.55 | 1 | < 0.1% |
| 0.65 | 1 | < 0.1% |
| 0.79 | 1 | < 0.1% |
| 0.8371428571 | 1 | < 0.1% |
| 0.84 | 2 | |
| 0.85 | 3 | |
| 1.002222222 | 1 | < 0.1% |
| 1.02 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 77183.6 | 1 | |
| 56157.5 | 1 | |
| 13305.5 | 1 | |
| 4453.43 | 1 | |
| 4287.63 | 1 | |
| 3861 | 1 | |
| 3096 | 1 | |
| 2653.95 | 1 | |
| 2583.76 | 1 | |
| 2033.1 | 1 |
recency_days
Real number (ℝ)
HIGH CORRELATION
| Distinct | 304 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 117.00451 |
| Minimum | 0 |
|---|---|
| Maximum | 373 |
| Zeros | 38 |
| Zeros (%) | 0.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 90.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 23 |
| median | 72 |
| Q3 | 199 |
| 95-th percentile | 337 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 176 |
Descriptive statistics
| Standard deviation | 111.29419 |
|---|---|
| Coefficient of variation (CV) | 0.95119574 |
| Kurtosis | -0.6351504 |
| Mean | 117.00451 |
| Median Absolute Deviation (MAD) | 62 |
| Skewness | 0.8132583 |
| Sum | 674297 |
| Variance | 12386.397 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 110 | 1.9% |
| 4 | 105 | 1.8% |
| 3 | 99 | 1.7% |
| 2 | 92 | 1.6% |
| 10 | 86 | 1.5% |
| 8 | 82 | 1.4% |
| 9 | 80 | 1.4% |
| 17 | 79 | 1.4% |
| 7 | 78 | 1.4% |
| 15 | 66 | 1.1% |
| Other values (294) | 4886 |
| Value | Count | Frequency (%) |
| 0 | 38 | 0.7% |
| 1 | 110 | |
| 2 | 92 | |
| 3 | 99 | |
| 4 | 105 | |
| 5 | 52 | |
| 7 | 78 | |
| 8 | 82 | |
| 9 | 80 | |
| 10 | 86 |
| Value | Count | Frequency (%) |
| 373 | 23 | |
| 372 | 23 | |
| 371 | 17 | |
| 369 | 4 | 0.1% |
| 368 | 13 | |
| 367 | 17 | |
| 366 | 15 | |
| 365 | 19 | |
| 364 | 11 | |
| 362 | 7 | 0.1% |
frequency
Real number (ℝ)
HIGH CORRELATION
| Distinct | 1243 |
|---|---|
| Distinct (%) | 21.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.55110525 |
| Minimum | 0.0054495913 |
|---|---|
| Maximum | 17 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 90.0 KiB |
Quantile statistics
| Minimum | 0.0054495913 |
|---|---|
| 5-th percentile | 0.011070111 |
| Q1 | 0.025244559 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 17 |
| Range | 16.99455 |
| Interquartile range (IQR) | 0.97475544 |
Descriptive statistics
| Standard deviation | 0.55129662 |
|---|---|
| Coefficient of variation (CV) | 1.0003473 |
| Kurtosis | 136.5065 |
| Mean | 0.55110525 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.7966628 |
| Sum | 3176.0195 |
| Variance | 0.30392797 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 2927 | |
| 2 | 51 | 0.9% |
| 0.0625 | 18 | 0.3% |
| 0.02777777778 | 17 | 0.3% |
| 0.02380952381 | 17 | 0.3% |
| 0.09090909091 | 15 | 0.3% |
| 0.08333333333 | 14 | 0.2% |
| 0.02941176471 | 13 | 0.2% |
| 0.07692307692 | 13 | 0.2% |
| 0.02127659574 | 13 | 0.2% |
| Other values (1233) | 2665 |
| Value | Count | Frequency (%) |
| 0.005449591281 | 1 | < 0.1% |
| 0.005464480874 | 1 | < 0.1% |
| 0.005479452055 | 1 | < 0.1% |
| 0.005494505495 | 1 | < 0.1% |
| 0.005586592179 | 2 | |
| 0.005602240896 | 1 | < 0.1% |
| 0.005617977528 | 2 | |
| 0.00566572238 | 1 | < 0.1% |
| 0.005681818182 | 2 | |
| 0.005698005698 | 3 |
| Value | Count | Frequency (%) |
| 17 | 1 | < 0.1% |
| 4 | 2 | < 0.1% |
| 3 | 4 | 0.1% |
| 2 | 51 | 0.9% |
| 1.142857143 | 1 | < 0.1% |
| 1 | 2927 | |
| 0.75 | 1 | < 0.1% |
| 0.6666666667 | 4 | 0.1% |
| 0.5588235294 | 1 | < 0.1% |
| 0.5388739946 | 1 | < 0.1% |
total_invoices
Real number (ℝ)
HIGH CORRELATION
| Distinct | 59 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4629533 |
| Minimum | 1 |
|---|---|
| Maximum | 209 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 90.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 4 |
| 95-th percentile | 11 |
| Maximum | 209 |
| Range | 208 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 6.8261859 |
|---|---|
| Coefficient of variation (CV) | 1.9712035 |
| Kurtosis | 310.00283 |
| Mean | 3.4629533 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.354763 |
| Sum | 19957 |
| Variance | 46.596814 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 2918 | |
| 2 | 835 | 14.5% |
| 3 | 508 | 8.8% |
| 4 | 388 | 6.7% |
| 5 | 242 | 4.2% |
| 6 | 172 | 3.0% |
| 7 | 143 | 2.5% |
| 8 | 98 | 1.7% |
| 9 | 68 | 1.2% |
| 10 | 54 | 0.9% |
| Other values (49) | 337 | 5.8% |
| Value | Count | Frequency (%) |
| 1 | 2918 | |
| 2 | 835 | 14.5% |
| 3 | 508 | 8.8% |
| 4 | 388 | 6.7% |
| 5 | 242 | 4.2% |
| 6 | 172 | 3.0% |
| 7 | 143 | 2.5% |
| 8 | 98 | 1.7% |
| 9 | 68 | 1.2% |
| 10 | 54 | 0.9% |
| Value | Count | Frequency (%) |
| 209 | 1 | |
| 201 | 1 | |
| 124 | 1 | |
| 97 | 1 | |
| 93 | 1 | |
| 91 | 1 | |
| 86 | 1 | |
| 73 | 1 | |
| 63 | 1 | |
| 62 | 1 |
items_qtt
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 1857 |
|---|---|
| Distinct (%) | 32.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 969.6979 |
| Minimum | 1 |
|---|---|
| Maximum | 196915 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 90.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 103 |
| median | 312 |
| Q3 | 800 |
| 95-th percentile | 2920.6 |
| Maximum | 196915 |
| Range | 196914 |
| Interquartile range (IQR) | 697 |
Descriptive statistics
| Standard deviation | 4408.3364 |
|---|---|
| Coefficient of variation (CV) | 4.5460926 |
| Kurtosis | 791.99992 |
| Mean | 969.6979 |
| Median Absolute Deviation (MAD) | 252 |
| Skewness | 23.138174 |
| Sum | 5588369 |
| Variance | 19433430 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 164 | 2.8% |
| 2 | 73 | 1.3% |
| 3 | 55 | 1.0% |
| 4 | 51 | 0.9% |
| 5 | 36 | 0.6% |
| 6 | 28 | 0.5% |
| 12 | 25 | 0.4% |
| 88 | 23 | 0.4% |
| 72 | 19 | 0.3% |
| 84 | 19 | 0.3% |
| Other values (1847) | 5270 |
| Value | Count | Frequency (%) |
| 1 | 164 | |
| 2 | 73 | |
| 3 | 55 | 1.0% |
| 4 | 51 | 0.9% |
| 5 | 36 | 0.6% |
| 6 | 28 | 0.5% |
| 7 | 19 | 0.3% |
| 8 | 18 | 0.3% |
| 9 | 8 | 0.1% |
| 10 | 17 | 0.3% |
| Value | Count | Frequency (%) |
| 196915 | 1 | |
| 80997 | 1 | |
| 80265 | 1 | |
| 77374 | 1 | |
| 74215 | 1 | |
| 69993 | 1 | |
| 64549 | 1 | |
| 64124 | 1 | |
| 63312 | 1 | |
| 58343 | 1 |
products_qtt
Real number (ℝ)
HIGH CORRELATION
| Distinct | 526 |
|---|---|
| Distinct (%) | 9.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 91.982821 |
| Minimum | 1 |
|---|---|
| Maximum | 7847 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 90.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 14 |
| median | 40 |
| Q3 | 105 |
| 95-th percentile | 332.9 |
| Maximum | 7847 |
| Range | 7846 |
| Interquartile range (IQR) | 91 |
Descriptive statistics
| Standard deviation | 209.90908 |
|---|---|
| Coefficient of variation (CV) | 2.2820465 |
| Kurtosis | 513.85265 |
| Mean | 91.982821 |
| Median Absolute Deviation (MAD) | 32 |
| Skewness | 17.802916 |
| Sum | 530097 |
| Variance | 44061.82 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 300 | 5.2% |
| 2 | 155 | 2.7% |
| 3 | 111 | 1.9% |
| 5 | 96 | 1.7% |
| 10 | 93 | 1.6% |
| 6 | 90 | 1.6% |
| 9 | 89 | 1.5% |
| 11 | 88 | 1.5% |
| 4 | 87 | 1.5% |
| 7 | 86 | 1.5% |
| Other values (516) | 4568 |
| Value | Count | Frequency (%) |
| 1 | 300 | |
| 2 | 155 | |
| 3 | 111 | 1.9% |
| 4 | 87 | 1.5% |
| 5 | 96 | 1.7% |
| 6 | 90 | 1.6% |
| 7 | 86 | 1.5% |
| 8 | 86 | 1.5% |
| 9 | 89 | 1.5% |
| 10 | 93 | 1.6% |
| Value | Count | Frequency (%) |
| 7847 | 1 | |
| 5675 | 1 | |
| 5111 | 1 | |
| 4595 | 1 | |
| 2700 | 1 | |
| 2379 | 1 | |
| 2076 | 1 | |
| 1818 | 1 | |
| 1677 | 1 | |
| 1637 | 1 |
avg_basket_size
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 2371 |
|---|---|
| Distinct (%) | 41.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 263.77715 |
| Minimum | 1 |
|---|---|
| Maximum | 74215 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 90.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 73 |
| median | 149.66667 |
| Q3 | 288 |
| 95-th percentile | 732 |
| Maximum | 74215 |
| Range | 74214 |
| Interquartile range (IQR) | 215 |
Descriptive statistics
| Standard deviation | 1189.9481 |
|---|---|
| Coefficient of variation (CV) | 4.5111873 |
| Kurtosis | 2822.4916 |
| Mean | 263.77715 |
| Median Absolute Deviation (MAD) | 96.333333 |
| Skewness | 49.088154 |
| Sum | 1520147.7 |
| Variance | 1415976.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 165 | 2.9% |
| 2 | 72 | 1.2% |
| 3 | 54 | 0.9% |
| 4 | 51 | 0.9% |
| 5 | 36 | 0.6% |
| 6 | 28 | 0.5% |
| 12 | 26 | 0.5% |
| 100 | 21 | 0.4% |
| 73 | 21 | 0.4% |
| 72 | 20 | 0.3% |
| Other values (2361) | 5269 |
| Value | Count | Frequency (%) |
| 1 | 165 | |
| 1.5 | 1 | < 0.1% |
| 2 | 72 | |
| 3 | 54 | 0.9% |
| 3.333333333 | 1 | < 0.1% |
| 4 | 51 | 0.9% |
| 5 | 36 | 0.6% |
| 5.333333333 | 1 | < 0.1% |
| 5.666666667 | 1 | < 0.1% |
| 6 | 28 | 0.5% |
| Value | Count | Frequency (%) |
| 74215 | 1 | |
| 40498.5 | 1 | |
| 14149 | 1 | |
| 13956 | 1 | |
| 7824 | 1 | |
| 6009.333333 | 1 | |
| 5964 | 1 | |
| 5198 | 1 | |
| 4300 | 1 | |
| 4280 | 1 |
avg_unique_basket_size
Real number (ℝ)
HIGH CORRELATION
| Distinct | 1170 |
|---|---|
| Distinct (%) | 20.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 36.933279 |
| Minimum | 0.2 |
|---|---|
| Maximum | 1110 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 90.0 KiB |
Quantile statistics
| Minimum | 0.2 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 7 |
| median | 15 |
| Q3 | 30.666667 |
| 95-th percentile | 173 |
| Maximum | 1110 |
| Range | 1109.8 |
| Interquartile range (IQR) | 23.666667 |
Descriptive statistics
| Standard deviation | 76.688683 |
|---|---|
| Coefficient of variation (CV) | 2.0764114 |
| Kurtosis | 33.17545 |
| Mean | 36.933279 |
| Median Absolute Deviation (MAD) | 10 |
| Skewness | 5.0956999 |
| Sum | 212846.49 |
| Variance | 5881.1541 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 323 | 5.6% |
| 2 | 167 | 2.9% |
| 3 | 117 | 2.0% |
| 7 | 106 | 1.8% |
| 8 | 104 | 1.8% |
| 5 | 104 | 1.8% |
| 9 | 101 | 1.8% |
| 10 | 100 | 1.7% |
| 11 | 97 | 1.7% |
| 6 | 95 | 1.6% |
| Other values (1160) | 4449 |
| Value | Count | Frequency (%) |
| 0.2 | 1 | < 0.1% |
| 0.25 | 3 | 0.1% |
| 0.3333333333 | 7 | |
| 0.4 | 1 | < 0.1% |
| 0.4090909091 | 1 | < 0.1% |
| 0.5 | 11 | |
| 0.5454545455 | 1 | < 0.1% |
| 0.5714285714 | 1 | < 0.1% |
| 0.6 | 1 | < 0.1% |
| 0.6176470588 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1110 | 1 | |
| 749 | 1 | |
| 731 | 1 | |
| 721 | 1 | |
| 704 | 1 | |
| 687 | 1 | |
| 676 | 1 | |
| 674 | 1 | |
| 661 | 1 | |
| 650 | 1 |
returns_qtt
Real number (ℝ)
HIGH CORRELATION SKEWED ZEROS
| Distinct | 218 |
|---|---|
| Distinct (%) | 3.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45.72202 |
| Minimum | 0 |
|---|---|
| Maximum | 80995 |
| Zeros | 4207 |
| Zeros (%) | 73.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 90.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 39 |
| Maximum | 80995 |
| Range | 80995 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1461.3444 |
|---|---|
| Coefficient of variation (CV) | 31.961502 |
| Kurtosis | 2786.029 |
| Mean | 45.72202 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 52.290856 |
| Sum | 263496 |
| Variance | 2135527.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4207 | |
| 1 | 191 | 3.3% |
| 2 | 158 | 2.7% |
| 3 | 107 | 1.9% |
| 4 | 90 | 1.6% |
| 6 | 72 | 1.2% |
| 5 | 64 | 1.1% |
| 8 | 49 | 0.9% |
| 12 | 49 | 0.9% |
| 7 | 48 | 0.8% |
| Other values (208) | 728 | 12.6% |
| Value | Count | Frequency (%) |
| 0 | 4207 | |
| 1 | 191 | 3.3% |
| 2 | 158 | 2.7% |
| 3 | 107 | 1.9% |
| 4 | 90 | 1.6% |
| 5 | 64 | 1.1% |
| 6 | 72 | 1.2% |
| 7 | 48 | 0.8% |
| 8 | 49 | 0.9% |
| 9 | 38 | 0.7% |
| Value | Count | Frequency (%) |
| 80995 | 1 | |
| 74215 | 1 | |
| 9014 | 1 | |
| 8060 | 1 | |
| 4627 | 1 | |
| 3768 | 1 | |
| 3335 | 1 | |
| 2975 | 1 | |
| 2022 | 1 | |
| 2012 | 1 |
| customer_id | gross_revenue | avg_ticket | recency_days | frequency | total_invoices | items_qtt | products_qtt | avg_basket_size | avg_unique_basket_size | returns_qtt | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| customer_id | 1.000 | -0.172 | -0.356 | 0.245 | 0.387 | -0.396 | -0.307 | -0.072 | -0.161 | 0.112 | -0.292 |
| gross_revenue | -0.172 | 1.000 | 0.349 | -0.406 | -0.435 | 0.626 | 0.910 | 0.837 | 0.715 | 0.390 | 0.431 |
| avg_ticket | -0.356 | 0.349 | 1.000 | -0.126 | -0.202 | 0.241 | 0.310 | -0.128 | 0.260 | -0.342 | 0.263 |
| recency_days | 0.245 | -0.406 | -0.126 | 1.000 | 0.486 | -0.595 | -0.495 | -0.378 | -0.201 | 0.044 | -0.326 |
| frequency | 0.387 | -0.435 | -0.202 | 0.486 | 1.000 | -0.801 | -0.520 | -0.365 | -0.140 | 0.090 | -0.373 |
| total_invoices | -0.396 | 0.626 | 0.241 | -0.595 | -0.801 | 1.000 | 0.696 | 0.537 | 0.168 | -0.165 | 0.548 |
| items_qtt | -0.307 | 0.910 | 0.310 | -0.495 | -0.520 | 0.696 | 1.000 | 0.786 | 0.795 | 0.314 | 0.465 |
| products_qtt | -0.072 | 0.837 | -0.128 | -0.378 | -0.365 | 0.537 | 0.786 | 1.000 | 0.621 | 0.663 | 0.321 |
| avg_basket_size | -0.161 | 0.715 | 0.260 | -0.201 | -0.140 | 0.168 | 0.795 | 0.621 | 1.000 | 0.581 | 0.191 |
| avg_unique_basket_size | 0.112 | 0.390 | -0.342 | 0.044 | 0.090 | -0.165 | 0.314 | 0.663 | 0.581 | 1.000 | -0.099 |
| returns_qtt | -0.292 | 0.431 | 0.263 | -0.326 | -0.373 | 0.548 | 0.465 | 0.321 | 0.191 | -0.099 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| customer_id | gross_revenue | avg_ticket | recency_days | frequency | total_invoices | items_qtt | products_qtt | avg_basket_size | avg_unique_basket_size | returns_qtt | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 17850 | 5391.21 | 18.152222 | 372.0 | 17.000000 | 34.0 | 1733.0 | 297.0 | 50.970588 | 0.617647 | 40.0 |
| 1 | 13047 | 3237.54 | 18.822907 | 31.0 | 0.029155 | 10.0 | 1391.0 | 172.0 | 139.100000 | 10.600000 | 36.0 |
| 2 | 12583 | 7281.38 | 29.479271 | 2.0 | 0.040323 | 15.0 | 5060.0 | 247.0 | 337.333333 | 7.666667 | 51.0 |
| 3 | 13748 | 948.25 | 33.866071 | 95.0 | 0.017921 | 5.0 | 439.0 | 28.0 | 87.800000 | 4.800000 | 0.0 |
| 4 | 15100 | 876.00 | 292.000000 | 333.0 | 0.073171 | 3.0 | 80.0 | 3.0 | 26.666667 | 0.333333 | 22.0 |
| 5 | 15291 | 4668.30 | 45.323301 | 25.0 | 0.042980 | 15.0 | 2103.0 | 103.0 | 140.200000 | 4.133333 | 29.0 |
| 6 | 14688 | 5630.87 | 17.219786 | 7.0 | 0.057221 | 21.0 | 3621.0 | 327.0 | 172.428571 | 7.047619 | 399.0 |
| 7 | 17809 | 5411.91 | 88.719836 | 16.0 | 0.033520 | 12.0 | 2057.0 | 61.0 | 171.416667 | 3.833333 | 42.0 |
| 8 | 15311 | 60767.90 | 25.543464 | 0.0 | 0.243316 | 91.0 | 38194.0 | 2379.0 | 419.714286 | 6.230769 | 474.0 |
| 9 | 14527 | 8508.82 | 8.753930 | 2.0 | 0.149457 | 55.0 | 2089.0 | 972.0 | 37.981818 | 6.000000 | 40.0 |
| customer_id | gross_revenue | avg_ticket | recency_days | frequency | total_invoices | items_qtt | products_qtt | avg_basket_size | avg_unique_basket_size | returns_qtt | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5936 | 22700 | 4839.42 | 78.055161 | 1.0 | 1.0 | 1.0 | 1074.0 | 62.0 | 1074.0 | 55.0 | 0.0 |
| 5937 | 13298 | 360.00 | 180.000000 | 1.0 | 1.0 | 1.0 | 96.0 | 2.0 | 96.0 | 2.0 | 0.0 |
| 5938 | 14569 | 227.39 | 18.949167 | 1.0 | 1.0 | 1.0 | 79.0 | 12.0 | 79.0 | 10.0 | 0.0 |
| 5939 | 22704 | 17.90 | 2.557143 | 1.0 | 1.0 | 1.0 | 14.0 | 7.0 | 14.0 | 7.0 | 0.0 |
| 5940 | 22705 | 3.35 | 1.675000 | 1.0 | 1.0 | 1.0 | 2.0 | 2.0 | 2.0 | 2.0 | 0.0 |
| 5941 | 22706 | 6637.59 | 10.452898 | 1.0 | 1.0 | 1.0 | 1748.0 | 635.0 | 1748.0 | 635.0 | 0.0 |
| 5942 | 22707 | 7689.23 | 10.518782 | 0.0 | 1.0 | 1.0 | 2011.0 | 731.0 | 2011.0 | 731.0 | 0.0 |
| 5943 | 22708 | 3217.20 | 54.528814 | 0.0 | 1.0 | 1.0 | 654.0 | 59.0 | 654.0 | 56.0 | 0.0 |
| 5944 | 22709 | 5664.89 | 25.985734 | 0.0 | 1.0 | 1.0 | 732.0 | 218.0 | 732.0 | 218.0 | 0.0 |
| 5945 | 12713 | 848.55 | 22.330263 | 0.0 | 1.0 | 1.0 | 508.0 | 38.0 | 508.0 | 38.0 | 0.0 |